package com.qf.dao;

import com.qf.entity.CheckGroup;
import com.qf.entity.SetMeal;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface SetMealLook {

    @Select("select * from t_setmeal where id = #{id}")
    SetMeal findById(Integer id);

    @Select("select * from t_checkgroup")
    List<CheckGroup> findAllGroup();

    @Select("SELECT checkgroup_id FROM t_setmeal_checkgroup LEFT JOIN t_setmeal ON setmeal_id=id WHERE id=#{id}")
    List<Integer> findAllGroupId(Integer id);
}
